﻿
create procedure [dbo].[usp_AddUpdateProject] 
@ProjectId as int, 
@ProjectDescription as nvarchar(max),  
@TeamId as int 
as  
if @ProjectId!=0

begin
update TblProject set
ProjectDescription = @ProjectDescription ,
TeamId = @TeamId where ProjectId = @ProjectId
end
else
begin  
insert into TblProject (ProjectDescription,TeamId) values (@ProjectDescription,@TeamId)
end
